from sqlite3api import CSqlLite3Api
from sqlite3api import CField
from sqlite3api import CTable

sqlLite3Api = CSqlLite3Api()

keyField1 = CField()
keyField1.m_name = 'id'
keyField1.m_value = '1'

keyField2 = CField()
keyField2.m_name = 'name'
keyField2.m_value = 'huchenkai'

sqlLite3Api.createTable('test',['id','name'])
sqlLite3Api.insertRecord('test',[keyField1,keyField2])

keyFieldList = []
keyFieldList.append(keyField1)
strFetchList = ['id','name']

print sqlLite3Api.getRecordsByKey('test',keyFieldList,strFetchList)